Database report it's a set of records which is passes some criteria. It is a common way to fetch data from database tables and use them later.
In this blog post you can find detailed instructions of how to create Reports in QuintaDB online database. Read about reports integration here.
In order to create Report we need to find some records and save result in the separate Report.
You can export to Excel all database records or use Search, Grouping functions and export only the found records.
Create database Views for the results of Search and Grouping.
For example we have UEFA Club Ranking Table.
The first step: open our test database (UEFA Club Ranking), it has 50 records (one per club) and go to the Records menu.
We need to find and save all the clubs from Spain in a separate table. Click on the "Search" button.
After the search click on button "Save Report" to create a new Report with the found records.
You can view, re-order, delete, edit name and open reports in Reports menu. Click on the "All reports" tab.
How to remove report
You can delete a report at any time you need. It’s very easy.
Please, see the screenshot below:
Also, you can rename, clone and change report parameters in the context menu.
Now open the report.
In the "Columns" menu, you can choose which columns will be hidden in the report and the report widget. Also, you can rename and re-order columns for the report widget. You can read more about "Columns" menu by this link.
Please note: the report's hidden columns settings apply only to the report owner.
For users group in the Team module, you must separately configure the field level access.
To export Report you only need to click on "Export" button.
You can also integrate your reports an add it to your Customer Portal.